package cn.tedu;

import com.alibaba.druid.pool.DruidDataSource;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class DBUtils {
    private static DruidDataSource ds;
    static {
        ds=new DruidDataSource();
        ds.setUrl("jdbc:mysql://localhost:3306/empdb?characterEncoding=utf8&serverTimezone=Asia/Shanghai");
        ds.setUsername("root");
        ds.setPassword("root");
        ds.setInitialSize(3);
        ds.setMaxActive(5);
    }
    public static Connection getConn() throws SQLException {
        Connection conn=ds.getConnection();
        return conn;
    }
}
